UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd5PG1i9X0kEj9Xb8xIuarhhuTQRSFfADlUdUBOMeiOE='
WHERE
key_id = '4c6ee742892a915484aac2b2c6cceb6da7eefa02a8f6ec0e0c293cd7ae4e1027'
AND (
token = 'd5PG1i9X0kEj9Xb8xIuarhhuTQRSFfADlUdUBOMeiOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)