UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o9LQ7sELY28vyqVGsnc8f0l6CVpvsHYtYFX6Mh4MMaw='
WHERE
key_id = '0cffa6b2e4c0ee4bd87914e1167270190323a6c99aea88a619bdc1f92a7abdd1'
AND (
token = 'o9LQ7sELY28vyqVGsnc8f0l6CVpvsHYtYFX6Mh4MMaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)