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