UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K6zjpnfoEgKdoXv5udv08qa3ryGUwYoSDL1MKf1uay8='
WHERE
key_id = '7207b87a0a0891d079cae777b0a54ffc7aee9fdcfa1788356927b8f371667808'
AND (
token = 'K6zjpnfoEgKdoXv5udv08qa3ryGUwYoSDL1MKf1uay8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)