UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C4nssKLF2nVh4a4c3EyjwxGYz/QZN5H6dEAAJNyhGhY='
WHERE
key_id = 'c7b9eb3c47fe84ab91a24a639eac86199de00a843a707bd8fce5ca9867644ff9'
AND (
token = 'C4nssKLF2nVh4a4c3EyjwxGYz/QZN5H6dEAAJNyhGhY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)