UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8ha2T4aQD0C+U8929rZeHzmq97uuSJjrjVnOAP59+fw=' 
WHERE 
  key_id = 'f0db20782e6d336af95e8bd8534a2751820540814667cc7981919e46144620dd' 
  AND (
    token = '8ha2T4aQD0C+U8929rZeHzmq97uuSJjrjVnOAP59+fw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032