UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3jf0qfB/KfcC5PGZzEoZMfOMYnrJvbh3a3X4gSK8gxY='
WHERE
key_id = '567d3b344667633be515365273cf8e70281330bb04c2a499c9f94256c65c50a1'
AND (
token = '3jf0qfB/KfcC5PGZzEoZMfOMYnrJvbh3a3X4gSK8gxY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)