UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4O84a6DKsoV5cSeUARg8ujwDfRK6bT4Uf2tVJz5phfk='
WHERE
key_id = '07bf7389556b4926ee9c3a9958f4b2d337cbe2075b52996b7e8303531ba987c6'
AND (
token = '4O84a6DKsoV5cSeUARg8ujwDfRK6bT4Uf2tVJz5phfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)