UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'y4I3AsTmY6DBmnAsArWREKkUiIsZ3w2axgxdKArVzOw=' 
WHERE 
  key_id = '02fea3b704dad636f2c21b3b1ddcf3221d6e2abd880d111acb9a38f2be5dcffe' 
  AND (
    token = 'y4I3AsTmY6DBmnAsArWREKkUiIsZ3w2axgxdKArVzOw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00093