UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dgOaJ0VifLVhtQVQDom8yorPpaz4UWVO6HYk5gFFypo='
WHERE
key_id = '291069df6695659c66194b2a71142224633b9603663385273a747e783dc0e63a'
AND (
token = 'dgOaJ0VifLVhtQVQDom8yorPpaz4UWVO6HYk5gFFypo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)