UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7zIFbtYqFbE1cWRrXlEaNBl26VDbQvL0YUBrI8u57Ws=' 
WHERE 
  key_id = '2b991c471005125b78f7a4e7ccb48c5300a42e2a3e3f88088b785ed39549a7d7' 
  AND (
    token = '7zIFbtYqFbE1cWRrXlEaNBl26VDbQvL0YUBrI8u57Ws=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044