UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bHl1p1ozaJePSBkJQAHxzEf/zkYBODIf1DDW4nE1BOI=' 
WHERE 
  key_id = '5a67e1419aee9433e067492a7ef0e17c6ce956dcd508d3426be9a0e177f1372f' 
  AND (
    token = 'bHl1p1ozaJePSBkJQAHxzEf/zkYBODIf1DDW4nE1BOI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027