UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'fPFpS4i4NPUmElgte3M4t+Hofet2iNbqTF83RUi87XE=' 
WHERE 
  key_id = '7fc1a42c56f69df14ed9a0a5453c22d4f36627b31fe4ac05b145c44b24e60f22' 
  AND (
    token = 'fPFpS4i4NPUmElgte3M4t+Hofet2iNbqTF83RUi87XE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024