UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VCYD7owkIOe4dQLUHJaYIP4/EUYLzd1jnwBw2yFNeAw='
WHERE
key_id = 'c629386b498eeadd9717152df5c474fa77e52c8865f4db41f9b7b8b1b10bf767'
AND (
token = 'VCYD7owkIOe4dQLUHJaYIP4/EUYLzd1jnwBw2yFNeAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)