UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NHmeI7BZlfxw2Ywih4iM0Q6QVKIjr8a+pH4WIv7EnDo='
WHERE
key_id = '5726b54d8c16f16ca6bd439f8b71b9f085e83fce2d7d7f06b5e8f17ec40b30bd'
AND (
token = 'NHmeI7BZlfxw2Ywih4iM0Q6QVKIjr8a+pH4WIv7EnDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)