UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5ALXNfM7pcX/08FcSRyfmW35TfrABrNsXtA8ncysLk4='
WHERE
key_id = 'dc4217581e3c4b477d01f1bd1aad5bc9da57f3a2291c451610d9b0126cd6de7e'
AND (
token = '5ALXNfM7pcX/08FcSRyfmW35TfrABrNsXtA8ncysLk4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)