UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/n/l3rZSAqE0yFY+6Oj7EKUyS3KVtz89b8jYSfOibJw='
WHERE
key_id = '404f2c20d1e2d879c7410003a12b28a77f024b3ea56815f569bc887099250123'
AND (
token = '/n/l3rZSAqE0yFY+6Oj7EKUyS3KVtz89b8jYSfOibJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)