UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7j16YPH5rZAuAIJpmyNlJS5Y0RvaygbiqLBMNwRXf/Y='
WHERE
key_id = 'bdb1edb8866b88a27479f62491ab4cf3390ebc264b7e4793514981c09ca6189a'
AND (
token = '7j16YPH5rZAuAIJpmyNlJS5Y0RvaygbiqLBMNwRXf/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)