UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'imgdi/SGodl3L/fR8kDhaepj9ElkJg7InQA0bJsl+w0=' 
WHERE 
  key_id = '6daf7181a7ab1b2ef52be9eee55c75c5d3e23d6b458a88708351a8ca3ed927c4' 
  AND (
    token = 'imgdi/SGodl3L/fR8kDhaepj9ElkJg7InQA0bJsl+w0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030