UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PwubykJiT/c8cegujwzKQEYL/ikYcXbYPnfiLupuiuk='
WHERE
key_id = 'a8ec65cdc589eea5a81f69dfa2179a6e80b6c9f05d1ae36adce6a48214fa7755'
AND (
token = 'PwubykJiT/c8cegujwzKQEYL/ikYcXbYPnfiLupuiuk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)