UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qnqzbFcE0aRvm2If0prL7ONQHQE3KlHx9jrsbjAPnZA='
WHERE
key_id = 'eec972dafd6928d5bc1a53d5f3a5bd2cbe4b9adca4ed18fe4380fb05ce3a6b3e'
AND (
token = 'qnqzbFcE0aRvm2If0prL7ONQHQE3KlHx9jrsbjAPnZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)