UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jrn0A3qN8ouxWm6mdmvdwTTuYOw947VEBdABv4CKcAQ='
WHERE
key_id = '7a80bf1cad0345544a52def5edcffbc5a44b84b3a19b3c96f3c3e913e1fe9613'
AND (
token = 'jrn0A3qN8ouxWm6mdmvdwTTuYOw947VEBdABv4CKcAQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)