UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7GaKuyrdHpsAyFdw4WJX5IYch8ohD6LS2KigA8ZdIag=' 
WHERE 
  key_id = '118f3258de46f7cc41d8c6a820aa02e54bddbce4a6815b88e359f9d996053b9b' 
  AND (
    token = '7GaKuyrdHpsAyFdw4WJX5IYch8ohD6LS2KigA8ZdIag=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023