UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sOP5VEocCDMGr323PZ1NlRB5vcVCRSBNt2ZAWqLhNGI='
WHERE
key_id = 'e0dced21ead83e5dd0aa596aa56de90eee879bd80f0c4e293ef63fee6cc6d27c'
AND (
token = 'sOP5VEocCDMGr323PZ1NlRB5vcVCRSBNt2ZAWqLhNGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)