UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NV9LSfag8VwcrW2KFb2DJK0OwT+qbPr4AW06u6k9eX4='
WHERE
key_id = 'ccd4a0ce63dc577d1435ee929347410d3a3625f47912b8e5770b84e82ac78112'
AND (
token = 'NV9LSfag8VwcrW2KFb2DJK0OwT+qbPr4AW06u6k9eX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)