UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7I07qG/5wSupT3sx+4cdJFic94Ew/O2n2wrcEz3Yfac='
WHERE
key_id = '1a652e101b85c09ee19f0689c4df72fa7900afa8a5a47339684ad4fa737af4e2'
AND (
token = '7I07qG/5wSupT3sx+4cdJFic94Ew/O2n2wrcEz3Yfac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)