UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vpRvm1y2vYTzI0tpgShcxt31OgFhyzWLIyf7KheaOTc='
WHERE
key_id = '7b0f04d5a21dbd66af3213671d6ef5026a1e0b13aa59c300ea2ef58108079deb'
AND (
token = 'vpRvm1y2vYTzI0tpgShcxt31OgFhyzWLIyf7KheaOTc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)