UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u4wPjh3brKVPrVGPtz9fiJcvsg5hLrHptiG+1fpASmY='
WHERE
key_id = 'cc670dd433cc76e953b9f21f2a2bcfdef53bd08ffde535e78a1452acdaf7a896'
AND (
token = 'u4wPjh3brKVPrVGPtz9fiJcvsg5hLrHptiG+1fpASmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)