UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pNgo5yJoq/8I1LSPnNOoYw9xvM+glgM0/g4GiuSISYE='
WHERE
key_id = 'a817589fcef73c5ecfd99345cc0bdb8e3962c18dc4ead4bff8d32825aa9cb563'
AND (
token = 'pNgo5yJoq/8I1LSPnNOoYw9xvM+glgM0/g4GiuSISYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)