UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hefwP0qoFyYD+9EoY65cOlkiGakeZ4JEWabVTDe/IP8='
WHERE
key_id = '966cf4acfacf70ba76c7f16a8dd8b56a0adf7ffa39147b248b0aa86076a431ce'
AND (
token = 'hefwP0qoFyYD+9EoY65cOlkiGakeZ4JEWabVTDe/IP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)