UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c6qHRqucpVQbE6tNARnBnfMFMj8WQvknlWNE6Fq/nFw='
WHERE
key_id = 'bba6cc8c090c71cc968f7d7887ac8cae4d1eb6474c545b192eaa45963e288df7'
AND (
token = 'c6qHRqucpVQbE6tNARnBnfMFMj8WQvknlWNE6Fq/nFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)