UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xUAXM50x4nd5b6KL71whV8dzXwHTLu5ngkhJbESWysc='
WHERE
key_id = '0bffa5d5a8dc49885072bebd8c754569e1aac2c6c7b77449bfbb38d5a5804ee2'
AND (
token = 'xUAXM50x4nd5b6KL71whV8dzXwHTLu5ngkhJbESWysc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)