UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IYhGHp7d5IXrFfVhcV88VAfXzRi0T26rFPxQz4gI8Fk='
WHERE
key_id = '29c9102eb0ef979000a49cf63abd1a2dad1a93e1e646a7a063083d0196cf3790'
AND (
token = 'IYhGHp7d5IXrFfVhcV88VAfXzRi0T26rFPxQz4gI8Fk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)