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