UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pfqT4vGZPcj/MUd10H/E+7f9KHYdga9KYQbgGrRthaw='
WHERE
key_id = '086b7edea91e0540153aafa890d1c004c06d1444e5c18703cc37b74543c3ace4'
AND (
token = 'pfqT4vGZPcj/MUd10H/E+7f9KHYdga9KYQbgGrRthaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)