UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WQAJhbFo6iIZUE7Eo0ZQqLE/8dk0Hlwr+96zdaXroLM=' 
WHERE 
  key_id = '8b95efa91a3f155f6f0b9146e03b010d09c8e73ef680b2b7a4386d410ee90844' 
  AND (
    token = 'WQAJhbFo6iIZUE7Eo0ZQqLE/8dk0Hlwr+96zdaXroLM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034