UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pUi3x4EY7HJ5/RRgCJs6BEi1+Gy+AsgpwbcrksNBTnU=' 
WHERE 
  key_id = 'b1fcfcf1966de14b53148f6b287a34df4b287016a6eda82cf15f0cbb37c4f246' 
  AND (
    token = 'pUi3x4EY7HJ5/RRgCJs6BEi1+Gy+AsgpwbcrksNBTnU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027