UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BCP0Hei6dJHzPnDyFJpF98xWecb44o45Q3x3DzX5HG8='
WHERE
key_id = '3681b4d45a173641781563ac0a3dec2e0a53af1bb882ca422274e28954aabbbc'
AND (
token = 'BCP0Hei6dJHzPnDyFJpF98xWecb44o45Q3x3DzX5HG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)