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