UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WVW78i+/HSLrkOHdKWe5nhUdIlZy+BPtTzVfov+zNzs='
WHERE
key_id = 'f9a9429bde4eb9f4f8368dcbbbf2be7ea650f673fda420e975195c318325f4bd'
AND (
token = 'WVW78i+/HSLrkOHdKWe5nhUdIlZy+BPtTzVfov+zNzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)