UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rY7biTwaossaC36A7E4o12ApeAU8ftXL3SJM1g04wTM=' 
WHERE 
  key_id = '5610a623a2d9a8e90c43cf7576913a61dd17cf86b951a7d69d217edf6b9c7a9f' 
  AND (
    token = 'rY7biTwaossaC36A7E4o12ApeAU8ftXL3SJM1g04wTM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023