UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9QXuIpIQLac4AgE1Budt/W7ghFwFZ70zX+OWLBlOf30=' 
WHERE 
  key_id = '126ab4109abf6b4d64934759dbcb35136464d74c89367e9d4746baff8f7f2dc0' 
  AND (
    token = '9QXuIpIQLac4AgE1Budt/W7ghFwFZ70zX+OWLBlOf30=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047