UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QzHMa1Gl+S+4weNHuZUrMPILbMelJ9MbAfWLgRISbVc='
WHERE
key_id = '8b89eaf66d90de7929ca1f9a5140a2a5cac287903324ae9dc152115ed5770217'
AND (
token = 'QzHMa1Gl+S+4weNHuZUrMPILbMelJ9MbAfWLgRISbVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)