UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z37QAaTjYyBpT6NSOnjltwW5zapoUbJGqm3CxYKSVRY='
WHERE
key_id = 'c778b9b6fab8d6eabb5ad67c82a542e1ee185b4376fd221bbaa93284ba84b182'
AND (
token = 'Z37QAaTjYyBpT6NSOnjltwW5zapoUbJGqm3CxYKSVRY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)