UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qrXTMRG4e7BJ/QL/km/hBH921POJ5RtGVlzASm6BXAc='
WHERE
key_id = 'ab4c36395bfa4860b67464aa0120f965b533ac70f22240052bfd5302e7d46ac2'
AND (
token = 'qrXTMRG4e7BJ/QL/km/hBH921POJ5RtGVlzASm6BXAc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)